Problem Note 56453: Table names might not be retrieved correctly when you use SAS/ACCESS® Interface to ODBC with the unixODBC driver manager
 |  |  |  |  |
Table names might be partially retrieved or not retrieved at all when you use SAS/ACCESS Interface to ODBC with the unixODBC driver manager in a SAS® UTF-8 session. You might encounter this issue in SAS Explorer, in DATASETS procedure output, or when you register tables in SAS® Management Console.
This issue is caused by how the driver manager handles the underlying data types. You might be able to circumvent the issue if you use the ODBC Driver Manager from Progress DataDirect.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | 64-bit Enabled AIX | 9.4 TS1M2 | 9.4 TS1M3 |
| 64-bit Enabled Solaris | 9.4 TS1M2 | 9.4 TS1M3 | ||
| HP-UX IPF | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Linux for x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
| Solaris for x64 | 9.4 TS1M2 | 9.4 TS1M3 | ||
A fix for this issue for SAS/ACCESS Interface to ODBC 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V58.html#56453A fix for this issue for SAS/ACCESS Interface to ODBC 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J40.html#56453
Table names might not be retrieved correctly when you use SAS/ACCESS Interface to ODBC with the unixODBC driver manager in a SAS UTF-8 session-encoded environment.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2015-08-21 10:51:50 |
| Date Created: | 2015-08-20 10:50:45 |